The End of a Myth: Distributed Transactions Can Scale

The common wisdom is that distributed transactions do not scale. But what if distributed transactions could be made scalable using the next generation of networks and a redesign of distributed databases? There would be no need for developers anymore to worry about co-partitioning schemes to achieve decent performance. Application development would become easier as data placement would no longer determine how scalable an application is. Hardware provisioning would be simplified as the system administrator can expect a linear scale-out when adding more machines rather than some complex sub-linear function, which is highly application specific. In this paper, we present the design of our novel scalable database system NAM-DB and show that distributed transactions with the very common Snapshot Isolation guarantee can indeed scale using the next generation of RDMA-enabled network technology without any inherent bottlenecks. Our experiments with the TPC-C benchmark show that our system scales linearly to over 6.5 million new-order (14.5 million total) distributed transactions per second on 56 machines.Comment: 12 page

The End of Slow Networks: It's Time for a Redesign

Next generation high-performance RDMA-capable networks will require a fundamental rethinking of the design and architecture of modern distributed DBMSs. These systems are commonly designed and optimized under the assumption that the network is the bottleneck: the network is slow and "thin", and thus needs to be avoided as much as possible. Yet this assumption no longer holds true. With InfiniBand FDR 4x, the bandwidth available to transfer data across network is in the same ballpark as the bandwidth of one memory channel, and it increases even further with the most recent EDR standard. Moreover, with the increasing advances of RDMA, the latency improves similarly fast. In this paper, we first argue that the "old" distributed database design is not capable of taking full advantage of the network. Second, we propose architectural redesigns for OLTP, OLAP and advanced analytical frameworks to take better advantage of the improved bandwidth, latency and RDMA capabilities. Finally, for each of the workload categories, we show that remarkable performance improvements can be achieved

Global, regional and national burden of bladder cancer and its attributable risk factors in 204 countries and territories, 1990–2019: a systematic analysis for the Global Burden of Disease study 2019

Introduction The current study determined the level and trends associated with the incidence, death and disability rates for bladder cancer and its attributable risk factors in 204 countries and territories, from 1990 to 2019, by age, sex and sociodemographic index (SDI; a composite measure of sociodemographic factors). Methods Various data sources from different countries, including vital registration and cancer registries were used to generate estimates. Mortality data and incidence data transformed to mortality estimates using the mortality to incidence ratio (MIR) were used in a cause of death ensemble model to estimate mortality. Mortality estimates were divided by the MIR to produce incidence estimates. Prevalence was calculated using incidence and MIR-based survival estimates. Age-specific mortality and standardised life expectancy were used to estimate years of life lost (YLLs). Prevalence was multiplied by disability weights to estimate years lived with disability (YLDs), while disability-adjusted life years (DALYs) are the sum of the YLLs and YLDs. All estimates were presented as counts and age-standardised rates per 100 000 population. Results Globally, there were 524 000 bladder cancer incident cases (95% uncertainty interval 476 000 to 569 000) and 229 000 bladder cancer deaths (211 000 to 243 000) in 2019. Age-standardised death rate decreased by 15.7% (8.6 to 21.0), during the period 1990–2019. Bladder cancer accounted for 4.39 million (4.09 to 4.70) DALYs in 2019, and the age-standardised DALY rate decreased significantly by 18.6% (11.2 to 24.3) during the period 1990–2019. In 2019, Monaco had the highest age-standardised incidence rate (31.9 cases (23.3 to 56.9) per 100 000), while Lebanon had the highest age-standardised death rate (10.4 (8.1 to 13.7)). Cabo Verde had the highest increase in age-standardised incidence (284.2% (214.1 to 362.8)) and death rates (190.3% (139.3 to 251.1)) between 1990 and 2019. In 2019, the global age-standardised incidence and death rates were higher among males than females, across all age groups and peaked in the 95+ age group. Globally, 36.8% (28.5 to 44.0) of bladder cancer DALYs were attributable to smoking, more so in males than females (43.7% (34.0 to 51.8) vs 15.2% (10.9 to 19.4)). In addition, 9.1% (1.9 to 19.6) of the DALYs were attributable to elevated fasting plasma glucose (FPG) (males 9.3% (1.6 to 20.9); females 8.4% (1.6 to 19.1)). Conclusions There was considerable variation in the burden of bladder cancer between countries during the period 1990–2019. Although there was a clear global decrease in the age-standardised death, and DALY rates, some countries experienced an increase in these rates. National policy makers should learn from these differences, and allocate resources for preventative measures, based on their country-specific estimates. In addition, smoking and elevated FPG play an important role in the burden of bladder cancer and need to be addressed with prevention programmes.publishedVersio

The global burden of adolescent and young adult cancer in 2019 : a systematic analysis for the Global Burden of Disease Study 2019

Background In estimating the global burden of cancer, adolescents and young adults with cancer are often overlooked, despite being a distinct subgroup with unique epidemiology, clinical care needs, and societal impact. Comprehensive estimates of the global cancer burden in adolescents and young adults (aged 15-39 years) are lacking. To address this gap, we analysed results from the Global Burden of Diseases, Injuries, and Risk Factors Study (GBD) 2019, with a focus on the outcome of disability-adjusted life-years (DALYs), to inform global cancer control measures in adolescents and young adults. Methods Using the GBD 2019 methodology, international mortality data were collected from vital registration systems, verbal autopsies, and population-based cancer registry inputs modelled with mortality-to-incidence ratios (MIRs). Incidence was computed with mortality estimates and corresponding MIRs. Prevalence estimates were calculated using modelled survival and multiplied by disability weights to obtain years lived with disability (YLDs). Years of life lost (YLLs) were calculated as age-specific cancer deaths multiplied by the standard life expectancy at the age of death. The main outcome was DALYs (the sum of YLLs and YLDs). Estimates were presented globally and by Socio-demographic Index (SDI) quintiles (countries ranked and divided into five equal SDI groups), and all estimates were presented with corresponding 95% uncertainty intervals (UIs). For this analysis, we used the age range of 15-39 years to define adolescents and young adults. Findings There were 1.19 million (95% UI 1.11-1.28) incident cancer cases and 396 000 (370 000-425 000) deaths due to cancer among people aged 15-39 years worldwide in 2019. The highest age-standardised incidence rates occurred in high SDI (59.6 [54.5-65.7] per 100 000 person-years) and high-middle SDI countries (53.2 [48.8-57.9] per 100 000 person-years), while the highest age-standardised mortality rates were in low-middle SDI (14.2 [12.9-15.6] per 100 000 person-years) and middle SDI (13.6 [12.6-14.8] per 100 000 person-years) countries. In 2019, adolescent and young adult cancers contributed 23.5 million (21.9-25.2) DALYs to the global burden of disease, of which 2.7% (1.9-3.6) came from YLDs and 97.3% (96.4-98.1) from YLLs. Cancer was the fourth leading cause of death and tenth leading cause of DALYs in adolescents and young adults globally. Interpretation Adolescent and young adult cancers contributed substantially to the overall adolescent and young adult disease burden globally in 2019. These results provide new insights into the distribution and magnitude of the adolescent and young adult cancer burden around the world. With notable differences observed across SDI settings, these estimates can inform global and country-level cancer control efforts. Copyright (C) 2021 The Author(s). Published by Elsevier Ltd.Peer reviewe

Burden of tracheal, bronchus, and lung cancer in North Africa and Middle East countries, 1990 to 2019: Results from the GBD study 2019

ObjectiveTo provide estimates on the regional and national burden of tracheal, bronchus, and lung (TBL) cancer and its attributable risk factors from 1990 to 2019 in the North Africa and Middle East (NAME) region.Methods and materialsThe Global Burden of Disease (GBD) 2019 data were used. Disability-adjusted life years (DALYs), death, incidence, and prevalence rates were categorized by sex and age groups in the NAME region, in 21 countries, from 1990 to 2019. Decomposition analysis was performed to calculate the proportion of responsible factors in the emergence of new cases. Data are presented as point estimates with their 95% uncertainty intervals (UIs).ResultsIn the NAME region, TBL cancer caused 15,396 and 57,114 deaths in women and men, respectively, in 2019. The age-standardized incidence rate (ASIR) increased by 0.7% (95% UI -20.6 to 24.1) and reached 16.8 per 100,000 (14.9 to 19.0) in 2019. All the age-standardized indices had a decreasing trend in men and an increasing trend in women from 1990 to 2019. Turkey (34.9 per 100,000 [27.6 to 43.5]) and Sudan (8.0 per 100,000 [5.2 to 12.5]) had the highest and lowest age-standardized prevalence rates (ASPRs) in 2019, respectively. The highest and lowest absolute slopes of change in ASPR, from 1990 to 2019, were seen in Bahrain (-50.0% (-63.6 to -31.7)) and the United Arab Emirates (-1.2% (-34.1 to 53.8)), respectively. The number of deaths attributable to risk factors was 58,816 (51,709 to 67,323) in 2019 and increased by 136.5%. Decomposition analysis showed that population growth and age structure change positively contributed to new incident cases. More than 80% of DALYs could be decreased by controlling risk factors, particularly tobacco use.ConclusionThe incidence, prevalence, and DALY rates of TBL cancer increased, and the death rate remained unchanged from 1990 to 2019. All the indices and contribution of risk factors decreased in men but increased in women. Tobacco is still the leading risk factor. Early diagnosis and tobacco cessation policies should be improved

Query Optimization in CrowdDB

While database management systems have successfully established themselves as reliable and highly optimized tools for managing data, they still fall short when it comes to certain types of queries, such as subjective comparisons and finding missing data. Crowdsourcing databases, such as CrowdDB, offer a solution by harnessing the knowledge and problem-solving abilities of large groups of people in order to perform the tasks at which humans excel. Nevertheless, people are prone to make mistakes in their judgements and give inaccurate answers, which can negatively impact the quality of results. To solve this issue, the commonly adopted approach is to ask the same question several times from the crowd. However, such redundancy significantly increases the cost of solutions, making it an infeasible approach for crowdsourcing databases where a large number of queries needs to be answered with a limited budget and possibly a certain level of quality. In this thesis, we address the inherent trade-off between cost and qualit